﻿CREATE TABLE [dbo].[t_Technician] (
    [ID]          INT           IDENTITY (1, 1) NOT NULL,
    [DealerID]    INT           NOT NULL,
    [FirstName]   VARCHAR (50)  NULL,
    [LastName]    VARCHAR (50)  NULL,
    [Phone]       VARCHAR (50)  NULL,
    [Cell]        VARCHAR (50)  NULL,
    [EMail]       VARCHAR (128) NULL,
    [MaxTrackers] TINYINT       NOT NULL,
    [Active]      BIT           NOT NULL
);

